﻿CREATE TABLE [dbo].[Suppliers] (
    [SupplierId]        INT            IDENTITY (1, 1) NOT NULL,
    [Name]              NVARCHAR (256) NOT NULL,
    [PhoneNumberWork]   NVARCHAR (20)  NULL,
    [FAX]               NVARCHAR (20)  NULL,
    [IBAN]              NVARCHAR (40)  NULL,
    [Notes]             NVARCHAR (MAX) NULL,
    [PhoneNumberMobile] NVARCHAR (20)  NULL,
    [PhoneNumberHome]   NVARCHAR (20)  NULL,
    [CF]                NVARCHAR (16)  NULL,
    [PI]                NVARCHAR (20)  NULL
);



